Microsoft SQL Server Based OLAP Technology at Raiffeisen Bank International
|
Case Code: CLIT010 Case Length: 5 Pages Period: 2012 Pub Date: 2020 Teaching Note: Available |
Price: Rs.200 Organization: Raiffeisen Bank International AG Industry: Banking Countries: Austria Themes: Business Intelligence Systems, Business Analytics, Data Warehouse, IT Infrastructure |
Abstract
Raiffeisen Bank International AG (RBI), an Austrian Bank, headquartered in Vienna was one of the most preferred banks in the Austria as well as Central and Eastern Europe and Asia.
The bank was dealing with humongous amount of data of its customers. Frequently this data was also used to create reports for analysis and evaluation of business. The bank was therefore using business analytics tool – Online Analytical Processing (OLAP) for its reporting and analysis purpose. The bank was using OLAP with IBM Cognos.
Over a period of time, increase in number of customers also increased the data. And so did their business requirements which called for more refined analytical reports. The bank wanted a sophisticated and powerful Business Intelligence (BI) tool but at the same time wanted to keep its costs low. So the bank decided to use Microsoft OLAP tool which would expand the existing reporting and analysis instead of completely replacing the existing system of business intelligence analysis.
Microsoft OLAP tool proved quite beneficial to the company. The reporting and analysis became precise as all unwanted data was filtered in early stages of analysis. Removal of unwanted data also made reporting process more flexible as employees were now able to select the data required for their reports instead of getting the entire database to go through.
Issues
- Use of OLAP for Business Intelligence and analytics
- Understand the reporting benefits achieved by implementing OLAP
Introduction
Raiffeisen Bank International AG (RBI), an Austrian Bank headquartered in Vienna, was one of the most preferred banks in Austria as well as in Central and Eastern Europe and Asia.
The bank dealt with a humongous amount of data pertaining to its customers. This data was also frequently used to create reports for analysis and evaluation of business. The bank was therefore using the business analytics tool Online Analytical Processing (OLAP) (Exhibit I) for its reporting and analysis purposes. It was using OLAP with IBM Cognos.
By 2019, the company had 46,873 employees and offered its services to close to 16.7 million customers through 2000 business outlets.
Over a period of time, an increase in the number of customers also led to an increase in the data and also to the bank’s business requirements, which called for more refined analytical reports. The bank wanted a sophisticated and powerful Business Intelligence (BI) tool while at the same time wanting to keep its costs low. So it decided to use the Microsoft OLAP tool which would expand the existing reporting and analysis instead of completely replacing the existing system of business intelligence analysis.
Keywords
Business Intelligence; OLAP; Reporting; Data Processing;Raiffeisen Bank; Analysis of business; evaluation of business; Online Analytical Processing; Business Intelligence tool
Buy this case study (Please select any one of the payment options)
| Price: Rs.200 |
Price: Rs.200 | PayPal (4 USD) |
